use online_news_editorial;
go

--insert into table_name(column1, column2) values('', '');


------Insert data into aspnet_Roles table
--insert into aspnet_Roles values('', 'A5ABBE5A-A7B8-44FD-8872-F7F724A0DB85', 'Approver', 'Publisher');
--insert into aspnet_Roles values('', 'B3DE010E-9EBD-42E7-9DC9-10DD676DFCE9', 'Editor', 'Editor');
--insert into aspnet_Roles values('', 'C129DCAF-58EA-4348-8A5C-0ABEB512D70B', 'Writer', 'Correspondent');
--insert into aspnet_Roles values('', '6C4E07FD-D1C4-4255-A017-2C65FF2EDDA5', 'WebAdmin', 'WebAdmin');
--insert into aspnet_Roles values('', '804C0BA7-B330-4724-A024-75A4EA04F6F5', 'SysAdmin', 'SysAdmin');
--go


----Insert data into AdvertisementBlocks table
insert into AdvertisementBlocks values('blk01', 'top', 'Ads block at top of site', 100, 50, 1);
insert into AdvertisementBlocks values('blk02', 'right sidebar', 'Ads block at right sidebar', 100, 50, 1);
insert into AdvertisementBlocks values('blk03', 'left sidebar', 'Ads block at left sidebar', 100, 50, 1);
insert into AdvertisementBlocks values('blk04', 'center', 'Ads block at center', 100, 50, 1);
go


----Insert data into AdvertisementContacts table (Identity insert)
insert into AdvertisementContacts (advContName, advContCompany, advContPhone)
	values('Bradley', 'Abbott Laboratories', '1-800-368-1133');
insert into AdvertisementContacts (advContName, advContCompany, advContPhone)
	values('Miguel', 'Brunswick Corporation', '(7)4959671833');
insert into AdvertisementContacts (advContName, advContCompany, advContPhone)
	values('Vincent', 'Coca-Cola Enterprises Inc.', '0800293229');
insert into AdvertisementContacts (advContName, advContCompany, advContPhone)
	values('Martin', 'Fairchild Semiconductor International Inc.', '800-96-83914');
insert into AdvertisementContacts (advContName, advContCompany, advContPhone)
	values('Alexandria', 'IMC Global Inc.', '+81 (3) 6679 7700');
insert into AdvertisementContacts (advContName, advContCompany, advContPhone)
	values('Natasha', 'J.B. Hunt Transport Services Inc.', '37114345');
insert into AdvertisementContacts (advContName, advContCompany, advContPhone)
	values('Garrett', 'Metaldyne Corporation', '+ 800 4445 8667');
insert into AdvertisementContacts (advContName, advContCompany, advContPhone)
	values('Martin', 'Owens-Illinois Inc', '0080044114824');
insert into AdvertisementContacts (advContName, advContCompany, advContPhone)
	values('Marcus', 'PepsiAmericas Inc.', '123 002065038');
insert into AdvertisementContacts (advContName, advContCompany, advContPhone)
	values('Monique', 'Walt Disney Co', '1800-80-18183');
go


----Insert data into Advertisements table (Identity insert)
insert into Advertisements (advContId, advBlockId, advDateCreate, advDateModify, advDateExpire, advActive, advLink, advImageLink, advAltText)
	values(1, 'blk01', '2014-05-01', '2014-05-01', '2014-06-01', 1, 'http://www.yame.vn', '', '');
insert into Advertisements (advContId, advBlockId, advDateCreate, advDateModify, advDateExpire, advActive, advLink, advImageLink, advAltText)
	values(2, 'blk02', '2014-06-01', '2014-06-01', '2014-07-01', 1, 'http://www.fptshop.com.vn', '', '');
insert into Advertisements (advContId, advBlockId, advDateCreate, advDateModify, advDateExpire, advActive, advLink, advImageLink, advAltText)
	values(3, 'blk01', '2014-06-20', '2014-06-20', '2014-07-20', 1, 'http://www.toms.com', '', '');
insert into Advertisements (advContId, advBlockId, advDateCreate, advDateModify, advDateExpire, advActive, advLink, advImageLink, advAltText)
	values(4, 'blk04', '2014-06-30', '2014-06-30', '2014-07-30', 1, 'http://www.logigear.com', '', '');
insert into Advertisements (advContId, advBlockId, advDateCreate, advDateModify, advDateExpire, advActive, advLink, advImageLink, advAltText)
	values(5, 'blk02', '2014-07-01', '2014-07-01', '2014-08-01', 1, 'http://www.rmit.edut.au', '', '');
insert into Advertisements (advContId, advBlockId, advDateCreate, advDateModify, advDateExpire, advActive, advLink, advImageLink, advAltText)
	values(6, 'blk02', '2014-07-20', '2014-07-20', '2014-08-20', 1, 'https://www.openoffice.org', '', '');
insert into Advertisements (advContId, advBlockId, advDateCreate, advDateModify, advDateExpire, advActive, advLink, advImageLink, advAltText)
	values(7, 'blk02', '2014-08-15', '2014-08-15', '2014-09-15', 1, 'http://www.whitehouse.gov', '', '');
insert into Advertisements (advContId, advBlockId, advDateCreate, advDateModify, advDateExpire, advActive, advLink, advImageLink, advAltText)
	values(8, 'blk01', '2014-09-01', '2014-09-01', '2014-10-01', 1, 'http://www.mp3.zing.vn', '', '');
insert into Advertisements (advContId, advBlockId, advDateCreate, advDateModify, advDateExpire, advActive, advLink, advImageLink, advAltText)
	values(9, 'blk04', '2014-10-25', '2014-10-25', '2014-11-25', 1, 'http://www.bbc.com', '', '');
insert into Advertisements (advContId, advBlockId, advDateCreate, advDateModify, advDateExpire, advActive, advLink, advImageLink, advAltText)
	values(10, 'blk04', '2014-11-30', '2014-11-30', '2014-12-30', 1, 'http://www.ibet888.org', '', '');
go



----Insert data into Divisions table
insert into Divisions values('div001', 'Editorial', 'The editorial board of a newspaper is responsible for collection, selection of news');
insert into Divisions values('div002', 'News', 'Division is responsible for editing and interpretation of business and finance, political events, society news, ...');
insert into Divisions values('div003', 'Entertainment', 'Division is responsible for editing and interpretation of information about movies, radio, television, and other activities for entertainment');
insert into Divisions values('div004', 'Sport', 'Division is responsible for editing and interpretation of news about sports events in and out of the country');
insert into Divisions values('div005', 'Digital', 'Division is responsible for editing and interpretation of latest technologies up to date');
go


----Insert data into Jobs table
insert into Jobs values('job0001', 'Editor in Chief', 'Editorial head', 1, 1);
insert into Jobs values('job0002', 'Sub-Editor', 'Editorial secretary. Presenter of news and reports', 1, 1);
insert into Jobs values('job0003', 'Managing Editor of News Division', 'Managing of Business and Finance, Politics news', 1, 1);
insert into Jobs values('job0004', 'Managing Editor of Enterainment Division', 'Managing of Entertainment news', 1, 1);
insert into Jobs values('job0005', 'Managing Editor of Sport Division', 'Managing of Sports news', 1, 1);
insert into Jobs values('job0006', 'Managing Editor of Digital Division', 'Managing of Technology news', 1, 1);
insert into Jobs values('job0007', 'News Editor', 'Editing and interpretation of Business and Finance, Politics news', 1, 1);
insert into Jobs values('job0008', 'Entertainment Editor', 'Editing and interpretation of Entertainment news', 1, 1);
insert into Jobs values('job0009', 'Sport Editor', 'Editing and interpretation of Sports news', 1, 1);
insert into Jobs values('job0010', 'Digital Editor', 'Editing and interpretation of Technology news', 1, 1);
insert into Jobs values('job0011', 'Correspondent', 'Journalist or commentator who contributes reports to a newspaper', 1, 1);
go


-----For purpose of demo,
-----Drop constraints between Employees table and aspnet_Users table
--Alter Table Employees drop constraint fk_Employees_Users
--go

----Insert data into Employees table
insert into Employees values('emp000001', null, 'Ngoc', 'Le', 'True', '2014-01-01', 'somewhere in the world', '0123456789', '2010-01-01', '2010-01-01', null, 1);--'D21F5053-FCF1-4495-9325-11B646211A7C'
insert into Employees values('emp000002', null, 'Hao', 'Du', 'True', '2014-01-01', 'somewhere in the world', '0123456789', '2012-08-23', '2012-08-23', null, 1);--'A43365B4-49CC-4A8F-BF41-3763EBC77C4C'
insert into Employees values('emp000003', null, 'Minh', 'Vo', 'True', '2014-01-01', 'somewhere in the world', '0123456789', '2013-12-31', '2013-12-31', null, 1);--'B3F3469A-025E-482F-8118-74DCB006ED8F'
insert into Employees values('emp000004', null, 'Phuong', 'Bui', 'False', '2014-01-01', 'somewhere in the world', '0123456789', '2009-05-08', '2009-05-08', null, 1);--'13CB5D31-F0EA-4662-A9C1-770F33368D31'
insert into Employees values('emp000005', null, 'Vy', 'Nguyen', 'False', '2014-01-01', 'somewhere in the world', '0123456789', '2014-01-10', '2014-01-10', null, 1);--'5C8846F8-1F9B-4808-B5F9-40B387CA99AA'
insert into Employees values('emp000006', null, 'Jessica', 'Miller', 'False', '2014-01-01', 'somewhere in the world', '0123456789', '2013-05-27', '2013-05-27', null, 1);--'1ED35671-BF27-4A51-8E83-1BD34DE37F32'
insert into Employees values('emp000007', null, 'Alejandro', 'Wilson', 'True', '2014-01-01', 'somewhere in the world', '0123456789', '2013-03-30', '2013-03-30', null, 1);--'B6589191-830E-4B85-B5FA-6A1C80FC3A1B'
insert into Employees values('emp000008', null, 'Gabriel', 'Gomez', 'True', '2014-01-01', 'somewhere in the world', '0123456789', '2012-12-21', '2012-12-21', null, 1);--'26F5D995-FFFC-43E7-B688-DD7BFEB69CFA'
insert into Employees values('emp000009', null, 'Cassandra', 'Thompson', 'False', '2014-01-01', 'somewhere in the world', '0123456789', '2013-11-10', '2013-11-10', null, 1);--'D211EF53-8E9A-4853-93A8-494D044941C1'
insert into Employees values('emp000010', null, 'Cynthia', 'Allen', 'False', '2014-01-01', 'somewhere in the world', '0123456789', '2012-12-31', '2012-12-31', null, 1);--'A2F50650-D546-41E5-B9AC-040B7EAAE521'
insert into Employees values('emp000011', null, 'Aiden', 'Wan', 1, '2014-01-01', 'somewhere in the world', '0123456789', '2014-01-01', '2014-01-01', null, 1);--'7BE069F0-3B2B-410B-B855-7D6F1755A9A1'
insert into Employees values('emp000012', null, 'Tiffany', 'Bet', 0, '2014-01-01', 'somewhere in the world', '0123456789', '2014-01-01', '2014-01-01', null, 1);--'2A6F0F52-B396-4DF2-A432-D6B4B9F64390'
insert into Employees values('emp000013', null, 'Justin', 'Timber', 1, '2014-01-01', 'somewhere in the world', '0123456789', '2012-11-26', '2012-11-26', null, 1);--'FAF53F2C-1DF4-4F58-AF93-413D910BF21A'
insert into Employees values('emp000014', null, 'Mango', 'Roftylake', 1, '2014-01-01', 'somewhere in the world', '0123456789', '2014-01-15', '2014-01-15', null, 1);--'714A4C1F-DA18-4B41-996C-726A5A7E2974'
insert into Employees values('emp000015', null, 'Can', 'Lydo', 1, '2014-01-01', 'somewhere in the world', '0123456789', '2013-08-23', '2013-08-23', null, 1);--'C0A6C1E5-BBB9-4AE2-8CF5-CE29ADC6E535'
go


----Insert data into Job Assignments table (Identity insert)
insert into JobAssignments(empId, divId, jobId, jaDateModify, jaDateStart)
	values('emp000001', 'div001', 'job0001', '2010-01-01', '2010-01-01');
insert into JobAssignments(empId, divId, jobId, jaDateModify, jaDateStart)
	values('emp000002', 'div001', 'job0002', '2012-08-23', '2012-08-23');
insert into JobAssignments(empId, divId, jobId, jaDateModify, jaDateStart)
	values('emp000003', 'div001', 'job0002', '2013-12-31', '2013-12-31');
insert into JobAssignments(empId, divId, jobId, jaDateModify, jaDateStart)
	values('emp000004', 'div002', 'job0003', '2009-05-08', '2009-05-08');
insert into JobAssignments(empId, divId, jobId, jaDateModify, jaDateStart)
	values('emp000005', 'div003', 'job0004', '2014-01-10', '2014-01-10');
insert into JobAssignments(empId, divId, jobId, jaDateModify, jaDateStart)
	values('emp000006', 'div004', 'job0005', '2013-05-27', '2013-05-27');
insert into JobAssignments(empId, divId, jobId, jaDateModify, jaDateStart)
	values('emp000007', 'div005', 'job0006', '2013-03-30', '2013-03-30');
insert into JobAssignments(empId, divId, jobId, jaDateModify, jaDateStart)
	values('emp000008', 'div002', 'job0007', '2012-12-21', '2012-12-21');
insert into JobAssignments(empId, divId, jobId, jaDateModify, jaDateStart)
	values('emp000009', 'div003', 'job0008', '2013-11-10', '2013-11-10');
insert into JobAssignments(empId, divId, jobId, jaDateModify, jaDateStart)
	values('emp000010', 'div004', 'job0009', '2012-12-31', '2012-12-31');
insert into JobAssignments(empId, divId, jobId, jaDateModify, jaDateStart)
	values('emp000011', 'div005', 'job0010', '2014-01-01', '2014-01-01');
insert into JobAssignments(empId, divId, jobId, jaDateModify, jaDateStart)
	values('emp000012', 'div002', 'job0011', '2014-01-01', '2014-01-01');
insert into JobAssignments(empId, divId, jobId, jaDateModify, jaDateStart)
	values('emp000013', 'div003', 'job0011', '2012-11-26', '2012-11-26');
insert into JobAssignments(empId, divId, jobId, jaDateModify, jaDateStart)
	values('emp000014', 'div004', 'job0011', '2014-01-15', '2014-01-15');
insert into JobAssignments(empId, divId, jobId, jaDateModify, jaDateStart)
	values('emp000015', 'div005', 'job0011', '2013-08-23', '2013-08-23');
go


----Insert data into Categories table
insert into Categories values('cat0001', 'News', 'Business and Finance, Political Events, Society, ...', null, 'div002');
insert into Categories values('cat0002', 'Entertainment', 'information about movies, radio, television, and other activities for entertainment', null, 'div003');
insert into Categories values('cat0003', 'Sports', 'news about sports events in and out of the country', null, 'div004');
insert into Categories values('cat0004', 'Digital', 'latest technologies up to date', null, 'div005');
insert into Categories values('cat0005', 'World News', 'international news', 'cat0001', 'div002');
insert into Categories values('cat0006', 'Vietnam News', 'nation news', 'cat0001', 'div002');
insert into Categories values('cat0007', 'Movie', 'Movies events in and out of the country', 'cat0002', 'div003');
insert into Categories values('cat0008', 'Music', 'Music all over the world', 'cat0002', 'div003');
go


----Insert data into Media table (Identity insert)
insert into Media (mName, mDescription, mLocation, mType, mDateCreate)
	values('MH370 Locator', 'Maryland Company Sends Locator to Plane Search', '', 'Video', '2014-03-27');
insert into Media (mName, mDescription, mLocation, mType, mDateCreate)
	values('HEW', 'HRW: Ethiopia Eavesdrops on Phone Calls, E-mail', '', 'Photo', '2014-03-28');
insert into Media (mName, mDescription, mLocation, mType, mDateCreate)
	values('Top 5 Countdown for Week Ending March 22 ', '(From L to R) Members of the British electro-pop band Bastille, Kyle Simmons, Chris Woody Wood, Dan Smith and Will Farquarson, pose for pictures at Capitol Studios in Los Angeles, Dec. 5, 2013.', '', 'Audio', '2014-03-28');
go


----Insert data into News table (Identity insert)
insert into News
(
	--newsId,--1 (int auto)
	catId--2 (cat---8)
	,newsTitle--3
	,newsIntroduceText--4
	,newsContent--5
	,author--6 (emp----11)
	,postingDate--7
	,modificationDate
	,processStatus--processLevel--9 (Approved; Edited; Posted; RejectedA; RejectedE)
	,verified-- (0; 1)
	,newsExclusion-- (0; 1)
	,publisher-- (emp----11)
	,publishDate
	,unpublishDate
	,numberOfView--14 (0; ....)
)values
		(
			--'1',
			'cat0005'
			,'Search for Malaysian Plane Shifts Following Credible Lead'
			,'Authorities said investigators have determined the plane was traveling faster and expending fuel quicker than previously estimated'
			
			,'Australian authorities said the search for the missing Malaysian jetliner has shifted over a thousand kilometers northeast following the emergence of a new "credible lead."
			The Australian Maritime Safety Authority (AMSA) said international investigators have determined the plane was traveling faster and expending fuel quicker than previously estimated, reducing the possible distance it flew.
			In a statement Friday, the AMSA said the new search area is about 319,000 kilometers. It is 1,850 kilometers west of the southwestern Australian city of Perth.'
			
			,'emp000012'
			,'2014-03-27 10:15:15.000'
			,'2014-03-27 10:25:15.000'
			,'Approved'
			,1
			,0
			,'emp000004'
			,'2014-03-27 10:30:15.000'
			,null
			,1
		);
insert into News(
	--newsId,--1 (int auto)
	catId--2 (cat---8)
	,newsTitle--3
	,newsIntroduceText--4
	,newsContent--5
	,author--6 (emp----11)
	,postingDate--7
	,modificationDate
	,processStatus--processLevel--9 (Approved; Edited; Posted; RejectedA; RejectedE)
	,verified-- (0; 1)
	,newsExclusion-- (0; 1)
	,publisher-- (emp----11)
	,publishDate
	,unpublishDate
	,numberOfView--14 (0; ....)
)values
		(
			--'2',
			'cat0004'
			,'HRW: Ethiopia Eavesdrops on Phone Calls, E-mail'
			,'ADDIS ABABA — A new report from Human Rights Watch says Ethiopia is using some of the world’s most advanced surveillance software to monitor communications from Ethiopians at home and abroad.'
			
			,'Felix Horne is the Horn of Africa researcher with the international human rights organization.
			He says the Ethiopian government has unlimited access to records of phone calls and emails of Ethiopians at home and abroad:
			“Inside Ethiopia, its control of its Chinese developed telecom system results in having unfettered access to phone records and metadata of all phone calls in the country," he said.
			"Outside the country, they are using western-made technology to target the activities of very specific members of the diaspora.
			These technologies are being provided by a company in Italy, called HackingTeam and a company in Germany called Gamma.”'
			
			,'emp000015'
			,'2014-03-28 14:20:00.000'
			,'2014-03-28 14:35:00.000'
			,'Approved'
			,1
			,0
			,'emp000007'
			,'2014-03-28 16:00.000'
			,null
			,1
		);
insert into News(
	--newsId,--1 (int auto)
	catId--2 (cat---8)
	,newsTitle--3
	,newsIntroduceText--4
	,newsContent--5
	,author--6 (emp----11)
	,postingDate--7
	,modificationDate
	,processStatus--processLevel--9 (Approved; Edited; Posted; RejectedA; RejectedE)
	,verified-- (0; 1)
	,newsExclusion-- (0; 1)
	,publisher-- (emp----11)
	,publishDate
	,unpublishDate
	,numberOfView--14 (0; ....)
)values
		(
			--'3',
			'cat0002'
			,'Top 5 Countdown for Week Ending March 22'
			,'We’re breaking out the five most popular songs in the Billboard Hot 100 pop singles chart, for the week ending March 22, 2014.'
			
			,'Last time we met, Pharrell Williams ruled both the Hot 100 and the U.K. pop album chart.
			What happens this week? The answer is on the way.
			First, however, let’s travel to fifth place, British rock quartet Bastille remains with “Pompeii.”
			This song has been certified double platinum in the United States, meaning it’s shifted two million downloads.
			Movement, we have movement! Unfortunately for Jason Derulo, it’s downward, as “Talk Dirty” featuring 2 Chainz slips a slot to number four.
			The video clip, however, is burning up cyberspace.
			It features cameo appearances from 23 celebrities, including Ariana Grande, One Direction, Robin Thicke, and even veteran interviewer Larry King.
			And yes, Jason’s fiancée Jordin Sparks is also in the mix.'
			
			,'emp000013'
			,'2014-03-28 14:20:00.000'
			,'2014-03-28 14:35:55.000'
			,'Approved'
			,1
			,0
			,'emp000005'
			,'2014-03-28 15:00:00.000'
			,null
			,1
		);
insert into News
(
	--newsId,--1 (int auto)
	catId--2 (cat---8)
	,newsTitle--3
	,newsIntroduceText--4
	,newsContent--5
	,author--6 (emp----11)
	,postingDate--7
	,modificationDate
	,processStatus--processLevel--9 (Approved; Edited; Posted; RejectedA; RejectedE)
	,verified-- (0; 1)
	,newsExclusion-- (0; 1)
	,publisher-- (emp----11)
	,publishDate
	,unpublishDate
	,numberOfView--14 (0; ....)
)values
		(
			--'4',
			'cat0001'--cate
			,'Lorem ipsum dolor sit amet'--title
			,'Consectetur adipiscing elit. Quisque in pretium dui. Donec non tincidunt tellus, mollis venenatis lorem.'--intro
			
			,'Lorem ipsum dolor sit amet, consectetur adipiscing elit.
			Quisque in pretium dui.
			Cras commodo, neque non mollis tempor, dolor tellus ornare ipsum, eu luctus orci magna quis nibh.
			Donec luctus augue ac sem lacinia, at volutpat augue commodo.
			Duis aliquet rhoncus magna eu porttitor.
			Nulla sit amet justo lectus.
			Donec non tincidunt tellus, mollis venenatis lorem.
			Mauris sed commodo libero.
			Mauris interdum mollis enim, quis posuere erat rutrum sit amet.
			Curabitur at fermentum diam, nec bibendum risus.
			Mauris condimentum nibh ut gravida ornare.
			Morbi ornare, elit vitae vestibulum vehicula, neque nunc elementum tortor, vel pulvinar felis enim a neque.
			Donec malesuada congue orci in ornare.'--content
			
			,'emp000012'--author
			,'2014-04-01 6:30:00.000'--date post
			,'2014-04-01 6:54:36.000'--date modify
			,'Approved'--status
			,1 --verify
			,0
			,'emp000004'--publisher
			,'2014-04-01 7:00:00.000'--date publish
			,null--date unpublish
			,1--view count
		);
insert into News
(
	--newsId,--1 (int auto)
	catId--2 (cat---8)
	,newsTitle--3
	,newsIntroduceText--4
	,newsContent--5
	,author--6 (emp----11)
	,postingDate--7
	,modificationDate
	,processStatus--processLevel--9 (Approved; Edited; Posted; RejectedA; RejectedE)
	,verified-- (0; 1)
	,newsExclusion-- (0; 1)
	,publisher-- (emp----11)
	,publishDate
	,unpublishDate
	,numberOfView--14 (0; ....)
)values
		(
			--'5',
			'cat0002'--cate
			,'Quisque in pretium dui.'--title
			,'Consectetur adipiscing elit. Quisque in pretium dui. Donec non tincidunt tellus, mollis venenatis lorem.'--intro
			
			,'Lorem ipsum dolor sit amet, consectetur adipiscing elit.
			Quisque in pretium dui.
			Cras commodo, neque non mollis tempor, dolor tellus ornare ipsum, eu luctus orci magna quis nibh.
			Donec luctus augue ac sem lacinia, at volutpat augue commodo.
			Duis aliquet rhoncus magna eu porttitor.
			Nulla sit amet justo lectus.
			Donec non tincidunt tellus, mollis venenatis lorem.
			Mauris sed commodo libero.
			Mauris interdum mollis enim, quis posuere erat rutrum sit amet.
			Curabitur at fermentum diam, nec bibendum risus.
			Mauris condimentum nibh ut gravida ornare.
			Morbi ornare, elit vitae vestibulum vehicula, neque nunc elementum tortor, vel pulvinar felis enim a neque.
			Donec malesuada congue orci in ornare.'--content
			
			,'emp000012'--author
			,'2014-04-01 7:40:00.000'--date post
			,'2014-04-01 8:15:00.000'--date modify
			,'Approved'--status
			,1 --verify
			,0
			,'emp000004'--publisher
			,'2014-04-01 14:15:00.000'--date publish
			,null--date unpublish
			,1--view count
		);
insert into News
(
	--newsId,--1 (int auto)
	catId--2 (cat---8)
	,newsTitle--3
	,newsIntroduceText--4
	,newsContent--5
	,author--6 (emp----11)
	,postingDate--7
	,modificationDate
	,processStatus--processLevel--9 (Approved; Edited; Posted; RejectedA; RejectedE)
	,verified-- (0; 1)
	,newsExclusion-- (0; 1)
	,publisher-- (emp----11)
	,publishDate
	,unpublishDate
	,numberOfView--14 (0; ....)
)values
		(
			--'6',
			'cat0004'--cate
			,'Mauris interdum mollis enim'--title
			,'Consectetur adipiscing elit. Quisque in pretium dui. Donec non tincidunt tellus, mollis venenatis lorem.'--intro
			
			,'Lorem ipsum dolor sit amet, consectetur adipiscing elit.
			Quisque in pretium dui.
			Cras commodo, neque non mollis tempor, dolor tellus ornare ipsum, eu luctus orci magna quis nibh.
			Donec luctus augue ac sem lacinia, at volutpat augue commodo.
			Duis aliquet rhoncus magna eu porttitor.
			Nulla sit amet justo lectus.
			Donec non tincidunt tellus, mollis venenatis lorem.
			Mauris sed commodo libero.
			Mauris interdum mollis enim, quis posuere erat rutrum sit amet.
			Curabitur at fermentum diam, nec bibendum risus.
			Mauris condimentum nibh ut gravida ornare.
			Morbi ornare, elit vitae vestibulum vehicula, neque nunc elementum tortor, vel pulvinar felis enim a neque.
			Donec malesuada congue orci in ornare.'--content
			
			,'emp000015'--author
			,'2014-04-01 14:20:00.000'--date post
			,'2014-04-02 14:40:18.000'--date modify
			,'Approved'--status
			,1 --verify
			,0
			,'emp000007'--publisher
			,'2014-04-02 15:20:00.000'--date publish
			,null--date unpublish
			,1--view count
		);
insert into News
(
	--newsId,--1 (int auto)
	catId--2 (cat---8)
	,newsTitle--3
	,newsIntroduceText--4
	,newsContent--5
	,author--6 (emp----11)
	,postingDate--7
	,modificationDate
	,processStatus--processLevel--9 (Approved; Edited; Posted; RejectedA; RejectedE)
	,verified-- (0; 1)
	,newsExclusion-- (0; 1)
	,publisher-- (emp----11)
	,publishDate
	,unpublishDate
	,numberOfView--14 (0; ....)
)values
		(
			--'7',
			'cat0001'--cate
			,'Donec non tincidunt tellus'--title
			,'Consectetur adipiscing elit. Quisque in pretium dui. Donec non tincidunt tellus, mollis venenatis lorem.'--intro
			
			,'Lorem ipsum dolor sit amet, consectetur adipiscing elit.
			Quisque in pretium dui.
			Cras commodo, neque non mollis tempor, dolor tellus ornare ipsum, eu luctus orci magna quis nibh.
			Donec luctus augue ac sem lacinia, at volutpat augue commodo.
			Duis aliquet rhoncus magna eu porttitor.
			Nulla sit amet justo lectus.
			Donec non tincidunt tellus, mollis venenatis lorem.
			Mauris sed commodo libero.
			Mauris interdum mollis enim, quis posuere erat rutrum sit amet.
			Curabitur at fermentum diam, nec bibendum risus.
			Mauris condimentum nibh ut gravida ornare.
			Morbi ornare, elit vitae vestibulum vehicula, neque nunc elementum tortor, vel pulvinar felis enim a neque.
			Donec malesuada congue orci in ornare.'--content
			
			,'emp000012'--author
			,'2014-04-01 8:20:00.000'--date post
			,'2014-04-01 8:55:36.000'--date modify
			,'Approved'--status
			,1 --verify
			,0
			,'emp000004'--publisher
			,'2014-04-01 9:15:00.000'--date publish
			,null--date unpublish
			,1--view count
		);

--insert into News
--(
--	--newsId,--1 (int auto)
--	catId--2 (cat---8)
--	,newsTitle--3
--	,newsIntroduceText--4
--	,newsContent--5
--	,author--6 (emp----11)
--	,postingDate--7
--	,modificationDate
--	,processStatus--processLevel--9 (Approved; Edited; Posted; RejectedA; RejectedE)
--	,verified-- (0; 1)
--	,newsExclusion-- (0; 1)
--	,publisher-- (emp----11)
--	,publishDate
--	,unpublishDate
--	,numberOfView--14 (0; ....)
--)values
--		(
--			''--cate
--			,''--title
--			,''--intro
			
--			,''--content
			
--			,''--author
--			,''--date post
--			,null--date modify
--			,''--status
--			, --verify
--			,''--publisher
--			,''--date publish
--			,null--date unpublish
--			,1--view count
--		);


----Insert data into Comments table
insert into Comments values('17306A87-927E-44F4-A33B-78E290FD22D7', 1, 'aosdbasbd', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-03-27', 0);
insert into Comments values('27306A87-927E-44F4-A33B-78E290FD22D7', 1, 'dfgiuhglk', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-03-27', 0);
insert into Comments values('37306A87-927E-44F4-A33B-78E290FD22D7', 1, 'woerhlkew', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-03-27', 0);
insert into Comments values('47306A87-927E-44F4-A33B-78E290FD22D7', 2, 'xcvhsldkf', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-03-28', 0);
insert into Comments values('57306A87-927E-44F4-A33B-78E290FD22D7', 2, 'auewbrle', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-03-28', 0);
insert into Comments values('67306A87-927E-44F4-A33B-78E290FD22D7', 1, 'dfigherlk', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-03-28', 0);
insert into Comments values('77306A87-927E-44F4-A33B-78E290FD22D7', 1, 'sfuwejb', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-03-28', 0);
insert into Comments values('87306A87-927E-44F4-A33B-78E290FD22D7', 3, 'ouhvnlknef', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-03-28', 0);
insert into Comments values('97306A87-927E-44F4-A33B-78E290FD22D7', 2, 'ewkljqqq', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-03-28', 0);
	insert into Comments values('18306A87-927E-44F4-A33B-78E290FD22D7', 1, 'sljfblsdkf', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-03-29', 0);
	insert into Comments values('28306A87-927E-44F4-A33B-78E290FD22D7', 4, 'sdfihsdlknf', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-04-01', 0);
	insert into Comments values('38306A87-927E-44F4-A33B-78E290FD22D7', 4, 'ghuberlbw', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-04-01', 0);
	insert into Comments values('48306A87-927E-44F4-A33B-78E290FD22D7', 5, 'yiukifhn', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-04-01', 0);
	insert into Comments values('58306A87-927E-44F4-A33B-78E290FD22D7', 7, 'rtyertwe', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-04-01', 0);
	insert into Comments values('68306A87-927E-44F4-A33B-78E290FD22D7', 4, 'gbnlnglk', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-04-01', 0);
	insert into Comments values('78306A87-927E-44F4-A33B-78E290FD22D7', 4, 'tyiwhlqhe', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-04-02', 0);
	insert into Comments values('88306A87-927E-44F4-A33B-78E290FD22D7', 6, 'soignslk', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-04-02', 0);
	insert into Comments values('98306A87-927E-44F4-A33B-78E290FD22D7', 5, 'afoejflkh', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-04-02', 0);
		insert into Comments values('19306A87-927E-44F4-A33B-78E290FD22D7', 5, 'usidfbjsfkj', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-04-02', 0);
		insert into Comments values('29306A87-927E-44F4-A33B-78E290FD22D7', 1, 'sfhlksdnfld', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-04-03', 0);
		insert into Comments values('39306A87-927E-44F4-A33B-78E290FD22D7', 1, 'sdfsjdfbldsk', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-04-04', 0);
		insert into Comments values('49306A87-927E-44F4-A33B-78E290FD22D7', 3, 'sdfljsdflk', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-04-05', 0);
		insert into Comments values('59306A87-927E-44F4-A33B-78E290FD22D7', 4, 'onlnohoi', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-04-05', 0);
		insert into Comments values('69306A87-927E-44F4-A33B-78E290FD22D7', 4, 'iopikuhuu', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-04-05', 0);
		insert into Comments values('79306A87-927E-44F4-A33B-78E290FD22D7', 4, 'qweqwasoi', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-04-06', 0);
		insert into Comments values('89306A87-927E-44F4-A33B-78E290FD22D7', 4, 'vbnfghdgs', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-04-07', 0);
		insert into Comments values('99306A87-927E-44F4-A33B-78E290FD22D7', 4, 'wereyttpii', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque in pretium dui.', '2014-04-07', 0);
go



----Insert data into MediaInNews table
Insert into MediaInNews values(1,1);
Insert into MediaInNews values(2,2);
Insert into MediaInNews values(3,3);
go



----Insert data into NewsRelated table
Insert into NewsRelated values(1,1);
Insert into NewsRelated values(2,2);
Insert into NewsRelated values(3,3);
go


--newsversions
----Insert data into NewsVersion table
---News1
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate)
values(1, null,'emp000012','Post',null,'2014-03-27 10:15:15.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate)
values(1, 'emp000008','emp000008','Post',null,'2014-03-27 10:25:15.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate)
values(1, null,'emp000004','Post',null,'2014-03-27 10:30:15.000');

---News2
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(2, null,'emp000015','Post',null,'2014-03-28 14:20:00.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(2, null,'emp000011','Reject',null,'2014-03-28 14:25:00.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(2, 'emp000015','emp000015','Post',null,'2014-03-28 14:30:00.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(2, 'emp000011','emp000011','Post',null,'2014-03-28 14:35:00.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(2, null,'emp000007','Post',null,'2014-03-28 16:00.000');


---News3
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(3, null,'emp000013','Post',null,'2014-03-28 14:20:00.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(3, 'emp000009','emp000009','Post',null,'2014-03-28 14:30:00.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(3, null,'emp000005','Reject',null,'2014-03-28 14:30:55.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(3, 'emp000009','emp000009','Post',null,'2014-03-28 14:35:55.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(3, null,'emp000005','Post',null,'2014-03-28 15:00:00.000');

---News4
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(4, null,'emp000012','Post',null,'2014-04-01 6:30:00.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(4, null,'emp000008','Reject',null,'2014-04-01 6:32:00.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(4, 'emp000012','emp000012','Post',null,'2014-04-01 6:35:00.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(4, 'emp000008','emp000008','Post',null,'2014-04-01 6:40:52.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(4, null,'emp000004','Reject',null,'2014-04-01 6:49:52.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(4, 'emp000008','emp000008','Post',null,'2014-04-01 6:54:36.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(4, null,'emp000004','Post',null,'2014-04-01 7:00:00.000');

---News5
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(5, null,'emp000012','Post',null,'2014-04-01 7:40:00.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(5, 'emp000008','emp000008','Post',null,'2014-04-01 8:15:00.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate) 
values(5, null,'emp000004','Post',null,'2014-04-01 14:15:00.000');

---News6
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate)
values(6, null,'emp000015','Post',null,'2014-04-01 14:20:00.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate)
values(6, 'emp000011','emp000011','Post',null,'2014-04-02 14:35:00.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate)
values(6, null,'emp000007','Reject',null,'2014-04-02 14:35:18.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate)
values(6, 'emp000011','emp000011','Post',null,'2014-04-02 14:40:18.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate)
values(6, null,'emp000007','Post',null,'2014-04-02 15:20:00.000');

---News7
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate)
values(7, null,'emp000012','Post',null,'2014-04-01 8:20:00.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate)
values(7, 'emp000008','emp000008','Post',null,'2014-04-01 8:55:36.000');
Insert into NewsVersions (newsId, verEditor, verSender, verProcessDirection, verComments, verDate)
values(7, null,'emp000004','Post',null,'2014-04-01 9:15:00.000');
go




